USE Catfax
GO
sp_configure 'clr enabled', 1;
GO
RECONFIGURE
GO
ALTER DATABASE Catfax SET TRUSTWORTHY ON;
GO
CREATE ASSEMBLY [CatFax.Sql.Client.XmlSerializers] from 'C:\catfax\SqlClr\CatFax.Sql.Client.XmlSerializers.dll'
WITH PERMISSION_SET = UNSAFE
GO
ALTER ASSEMBLY [CatFax.Sql.Client] WITH VISIBILITY = ON
GO	
CREATE PROCEDURE GetAuditRow
@rowSpecification nvarchar(max)
AS 
EXTERNAL NAME [CatFax.Sql.Client].[CatFax.Sql.Client.AuditRowDataSource].GetAuditRow
GO
CREATE PROCEDURE AddAuditRow
@rowSpecification nvarchar(max)
AS
EXTERNAL NAME [CatFax.Sql.Client].[CatFax.Sql.Client.AuditRowDataSource].AddAuditRow
GO
